USE AdventureWorks2008
GO

SELECT p.FirstName, p.LastName, (s.Rate + s.RateChangeDate)
FROM Person.Person AS p
INNER JOIN HumanResources.EmployeePayHistory AS s
ON p.BusinessEntityID = s.BusinessEntityID

ORDER BY p.BusinessEntityID